if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_HangTon_GetSoLuongTonKhoOfHangHoaByMaHang]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_HangTon_GetSoLuongTonKhoOfHangHoaByMaHang]
GO
CREATE PROCEDURE [sp_HangTon_GetSoLuongTonKhoOfHangHoaByMaHang](
		@Ma_hang				int
)
AS
BEGIN
	SELECT So_luong
	FROM HangTon 
	WHERE Ma_hang =  @Ma_hang
END

